/**
 *  iBizSys 5.0 机器人生产代码（不要直接修改当前代码）
 *  http://www.ibizsys.net
 */
package com.sa.litetwo.srv.card.demodel;



import net.ibizsys.paas.core.DEDataQuery;
import net.ibizsys.paas.core.DEDataQueryCodes;
import net.ibizsys.paas.core.DEDataQueryCode;
import net.ibizsys.paas.core.DEDataQueryCodeExp;
import net.ibizsys.paas.core.DEDataQueryCodeCond;

@DEDataQuery(id="B41A6586-0240-402F-A36D-73CAB6BF7293",name="DEFAULT")
@DEDataQueryCodes({
 @DEDataQueryCode(querycode="SELECT t1.`BTJT`, t1.`CREATEDATE`, t1.`CREATEMAN`, t1.`CSRQ`, t1.`DD`, t1.`DGSJ`, t1.`ENABLE`, t1.`GG_CARDID`, t1.`GG_CARDNAME`, t1.`GG_WORKNAME`, t1.`GQSY`, t1.`GRBQ`, t1.`GRZY`, t1.`GZLX`, year(now())-year(t1.`KSGZNF`)+1 AS `GZNX`, t1.`HKGJ`, t1.`HY`, t1.`HYZT`, t1.`JBGZ`, t1.`JJYJ`, t1.`JTZZ`, t1.`KSGZNF`, t1.`MQNSR`, year(now())-year(t1.`CSRQ`)+1 AS `NL`, t1.`QTLXFS`, t1.`QWNX`, t1.`QZZT`, t1.`SG`, t1.`SJ`, t1.`SJZH`, t1.`TJGWSZCS`, t1.`TJSJ`, t1.`UPDATEDATE`, t1.`UPDATEMAN`, t1.`XB`, t1.`XM`, t1.`YTJQY`, t1.`YX`, t1.`ZD`, t1.`ZGXL`, t1.`ZJH`, t1.`ZN`, t1.`ZN_FDC`, t1.`ZN_HLW`, t1.`ZN_JRYH`, t1.`ZN_JXZZ`, t1.`ZN_SWYY`, t1.`ZN_SYLS`, t1.`ZP`, t1.`ZWPJ`, t1.`ZZMM` FROM `T_GG_CARD` t1  ",querycodetemp="SELECT t1.`BTJT`, t1.`CREATEDATE`, t1.`CREATEMAN`, t1.`CSRQ`, t1.`DD`, t1.`DGSJ`, t1.`ENABLE`, t1.`GG_CARDID`, t1.`GG_CARDNAME`, t1.`GG_WORKNAME`, t1.`GQSY`, t1.`GRBQ`, t1.`GRZY`, t1.`GZLX`, year(now())-year(t1.`KSGZNF`)+1 AS `GZNX`, t1.`HKGJ`, t1.`HY`, t1.`HYZT`, t1.`JBGZ`, t1.`JJYJ`, t1.`JTZZ`, t1.`KSGZNF`, t1.`MQNSR`, year(now())-year(t1.`CSRQ`)+1 AS `NL`, t1.`QTLXFS`, t1.`QWNX`, t1.`QZZT`, t1.`SG`, t1.`SJ`, t1.`SJZH`, t1.`TJGWSZCS`, t1.`TJSJ`, t1.`UPDATEDATE`, t1.`UPDATEMAN`, t1.`XB`, t1.`XM`, t1.`YTJQY`, t1.`YX`, t1.`ZD`, t1.`ZGXL`, t1.`ZJH`, t1.`ZN`, t1.`ZN_FDC`, t1.`ZN_HLW`, t1.`ZN_JRYH`, t1.`ZN_JXZZ`, t1.`ZN_SWYY`, t1.`ZN_SYLS`, t1.`ZP`, t1.`ZWPJ`, t1.`ZZMM` FROM `T_GG_CARD_TMP` t1  ",declarecode="",dbtype="MYSQL5",
 fieldexps={@DEDataQueryCodeExp(name="BTJT",expression="t1.`BTJT`")
,@DEDataQueryCodeExp(name="CREATEDATE",expression="t1.`CREATEDATE`")
,@DEDataQueryCodeExp(name="CREATEMAN",expression="t1.`CREATEMAN`")
,@DEDataQueryCodeExp(name="CSRQ",expression="t1.`CSRQ`")
,@DEDataQueryCodeExp(name="DD",expression="t1.`DD`")
,@DEDataQueryCodeExp(name="DGSJ",expression="t1.`DGSJ`")
,@DEDataQueryCodeExp(name="ENABLE",expression="t1.`ENABLE`")
,@DEDataQueryCodeExp(name="GG_CARDID",expression="t1.`GG_CARDID`")
,@DEDataQueryCodeExp(name="GG_CARDNAME",expression="t1.`GG_CARDNAME`")
,@DEDataQueryCodeExp(name="GG_WORKNAME",expression="t1.`GG_WORKNAME`")
,@DEDataQueryCodeExp(name="GQSY",expression="t1.`GQSY`")
,@DEDataQueryCodeExp(name="GRBQ",expression="t1.`GRBQ`")
,@DEDataQueryCodeExp(name="GRZY",expression="t1.`GRZY`")
,@DEDataQueryCodeExp(name="GZLX",expression="t1.`GZLX`")
,@DEDataQueryCodeExp(name="GZNX",expression="year(now())-year(t1.`KSGZNF`)+1")
,@DEDataQueryCodeExp(name="HKGJ",expression="t1.`HKGJ`")
,@DEDataQueryCodeExp(name="HY",expression="t1.`HY`")
,@DEDataQueryCodeExp(name="HYZT",expression="t1.`HYZT`")
,@DEDataQueryCodeExp(name="JBGZ",expression="t1.`JBGZ`")
,@DEDataQueryCodeExp(name="JJYJ",expression="t1.`JJYJ`")
,@DEDataQueryCodeExp(name="JTZZ",expression="t1.`JTZZ`")
,@DEDataQueryCodeExp(name="KSGZNF",expression="t1.`KSGZNF`")
,@DEDataQueryCodeExp(name="MQNSR",expression="t1.`MQNSR`")
,@DEDataQueryCodeExp(name="NL",expression="year(now())-year(t1.`CSRQ`)+1")
,@DEDataQueryCodeExp(name="QTLXFS",expression="t1.`QTLXFS`")
,@DEDataQueryCodeExp(name="QWNX",expression="t1.`QWNX`")
,@DEDataQueryCodeExp(name="QZZT",expression="t1.`QZZT`")
,@DEDataQueryCodeExp(name="SG",expression="t1.`SG`")
,@DEDataQueryCodeExp(name="SJ",expression="t1.`SJ`")
,@DEDataQueryCodeExp(name="SJZH",expression="t1.`SJZH`")
,@DEDataQueryCodeExp(name="TJGWSZCS",expression="t1.`TJGWSZCS`")
,@DEDataQueryCodeExp(name="TJSJ",expression="t1.`TJSJ`")
,@DEDataQueryCodeExp(name="UPDATEDATE",expression="t1.`UPDATEDATE`")
,@DEDataQueryCodeExp(name="UPDATEMAN",expression="t1.`UPDATEMAN`")
,@DEDataQueryCodeExp(name="XB",expression="t1.`XB`")
,@DEDataQueryCodeExp(name="XM",expression="t1.`XM`")
,@DEDataQueryCodeExp(name="YTJQY",expression="t1.`YTJQY`")
,@DEDataQueryCodeExp(name="YX",expression="t1.`YX`")
,@DEDataQueryCodeExp(name="ZD",expression="t1.`ZD`")
,@DEDataQueryCodeExp(name="ZGXL",expression="t1.`ZGXL`")
,@DEDataQueryCodeExp(name="ZJH",expression="t1.`ZJH`")
,@DEDataQueryCodeExp(name="ZN",expression="t1.`ZN`")
,@DEDataQueryCodeExp(name="ZN_FDC",expression="t1.`ZN_FDC`")
,@DEDataQueryCodeExp(name="ZN_HLW",expression="t1.`ZN_HLW`")
,@DEDataQueryCodeExp(name="ZN_JRYH",expression="t1.`ZN_JRYH`")
,@DEDataQueryCodeExp(name="ZN_JXZZ",expression="t1.`ZN_JXZZ`")
,@DEDataQueryCodeExp(name="ZN_SWYY",expression="t1.`ZN_SWYY`")
,@DEDataQueryCodeExp(name="ZN_SYLS",expression="t1.`ZN_SYLS`")
,@DEDataQueryCodeExp(name="ZP",expression="t1.`ZP`")
,@DEDataQueryCodeExp(name="ZWPJ",expression="t1.`ZWPJ`")
,@DEDataQueryCodeExp(name="ZZMM",expression="t1.`ZZMM`")
},
 conds={@DEDataQueryCodeCond(condition="t1.ENABLE = 1")
})})
/**
 *  实体数据查询 [DEFAULT]模型基类
 */ 
public class GG_CARDDefaultDQModel extends net.ibizsys.paas.demodel.DEDataQueryModelBase{

   public GG_CARDDefaultDQModel(){
        super();

        this.initAnnotation(GG_CARDDefaultDQModel.class);
   }

}